class ReportSystem implements Comparable {
	static constraints = {
		id()
		codeSystem(unique:true,blank:false)
		descrSystem(blank:true,nullable:true)
		reportDirectory(blank:false,nullabe:false)
		//have databaseType because MySql and Oracle date are read differently
		//refer to WhereClauseService.applyDateFilterMySql and
		//WhereClauseService.applyDateFilterOracle
		databaseType(inList:["MySql","Oracle"])
		systemEnded(maxSize:1,inList:["N","Y"])
		dateCreated()
		reports()
	}
	SortedSet reports
	static hasMany = [reports:Report]
	
	Integer id
	String 	codeSystem
	String	descrSystem
	String	reportDirectory
	String  databaseType
	String 	systemEnded
	Date	dateCreated
	
	String toString(){
		codeSystem
	}
	
	int compareTo(obj){
		codeSystem.compareTo(obj.codeSystem)
	}
}
